#region Copyright (c) 2006-2012 nHydrate.org, All Rights Reserved
// --------------------------------------------------------------------- *
//                           NHYDRATE.ORG                                *
//              Copyright (c) 2006-2012 All Rights reserved              *
//                                                                       *
//                                                                       *
// This file and its contents are protected by United States and         *
// International copyright laws.  Unauthorized reproduction and/or       *
// distribution of all or any portion of the code contained herein       *
// is strictly prohibited and will result in severe civil and criminal   *
// penalties.  Any violations of this copyright will be prosecuted       *
// to the fullest extent possible under law.                             *
//                                                                       *
// THE SOURCE CODE CONTAINED HEREIN AND IN RELATED FILES IS PROVIDED     *
// TO THE REGISTERED DEVELOPER FOR THE PURPOSES OF EDUCATION AND         *
// TROUBLESHOOTING. UNDER NO CIRCUMSTANCES MAY ANY PORTION OF THE SOURCE *
// CODE BE DISTRIBUTED, DISCLOSED OR OTHERWISE MADE AVAILABLE TO ANY     *
// THIRD PARTY WITHOUT THE EXPRESS WRITTEN CONSENT OF THE NHYDRATE GROUP *
//                                                                       *
// UNDER NO CIRCUMSTANCES MAY THE SOURCE CODE BE USED IN WHOLE OR IN     *
// PART, AS THE BASIS FOR CREATING A PRODUCT THAT PROVIDES THE SAME, OR  *
// SUBSTANTIALLY THE SAME, FUNCTIONALITY AS THIS PRODUCT                 *
//                                                                       *
// THE REGISTERED DEVELOPER ACKNOWLEDGES THAT THIS SOURCE CODE           *
// CONTAINS VALUABLE AND PROPRIETARY TRADE SECRETS OF NHYDRATE,          *
// THE REGISTERED DEVELOPER AGREES TO EXPEND EVERY EFFORT TO             *
// INSURE ITS CONFIDENTIALITY.                                           *
//                                                                       *
// THE END USER LICENSE AGREEMENT (EULA) ACCOMPANYING THE PRODUCT        *
// PERMITS THE REGISTERED DEVELOPER TO REDISTRIBUTE THE PRODUCT IN       *
// EXECUTABLE FORM ONLY IN SUPPORT OF APPLICATIONS WRITTEN USING         *
// THE PRODUCT.  IT DOES NOT PROVIDE ANY RIGHTS REGARDING THE            *
// SOURCE CODE CONTAINED HEREIN.                                         *
//                                                                       *
// THIS COPYRIGHT NOTICE MAY NOT BE REMOVED FROM THIS FILE.              *
// --------------------------------------------------------------------- *
#endregion
using System;
using System.Xml;
using nHydrate.Generator.Common;
using nHydrate.Generator.Common.GeneratorFramework;
using nHydrate.Generator.Common.Util;

namespace nHydrate.Generator.Models
{
	public class RowEntry : BaseModelObject
	{
		#region Member Variables

		protected CellEntryCollection _cellEntries = null;

		#endregion

		#region Constructor

		public RowEntry(INHydrateModelObject root)
			: base(root)
		{
			_cellEntries = new CellEntryCollection(this.Root);
		}

		#endregion

		#region Property Implementations

		public CellEntryCollection CellEntries
		{
			get { return _cellEntries; }
			set { _cellEntries = value; }
		}

		#endregion

		#region Methods

		public string GetCodeIdentifier(Table table)
		{
			try
			{
				var name = string.Empty;
				var description = string.Empty;
				foreach (CellEntry cellEntry in this.CellEntries)
				{
					var column = cellEntry.ColumnRef.Object as Column;
					var pk = table.PrimaryKeyColumns.FirstOrDefault<Column>() as Column;
					if (column != null)
					{
						if (StringHelper.Match(column.Name, "name"))
							name = ValidationHelper.MakeCodeIdentifer(cellEntry.Value);
						if (StringHelper.Match(column.Name, "description"))
							description = cellEntry.Value;
					}
				}

				if (string.IsNullOrEmpty(name)) name = description;
				return name;

			}
			catch (Exception ex)
			{
				throw;
			}

		}

		public string GetCodeIdValue(Table table)
		{
			var id = string.Empty;
			var name = string.Empty;
			var description = string.Empty;
			foreach (CellEntry cellEntry in this.CellEntries)
			{
				var column = (Column)cellEntry.ColumnRef.Object;
				var pk = (Column)table.PrimaryKeyColumns[0];
				if (column != null)
				{
					if (column.Key == pk.Key)
						id = cellEntry.Value;
					if (StringHelper.Match(column.Name, "name"))
						name = ValidationHelper.MakeCodeIdentifer(cellEntry.Value);
					if (StringHelper.Match(column.Name, "description"))
						description = cellEntry.Value;
				}
			}

			if (string.IsNullOrEmpty(name)) name = description;
			return id;
		}

		public string GetCodeDescription(Table table)
		{
			var id = string.Empty;
			var name = string.Empty;
			var description = string.Empty;
			foreach (CellEntry cellEntry in this.CellEntries)
			{
				var column = (Column)cellEntry.ColumnRef.Object;
				var pk = (Column)table.PrimaryKeyColumns[0];
				if (column != null)
				{
					if (column.Key == pk.Key)
						id = cellEntry.Value;
					if (StringHelper.Match(column.Name, "name"))
						name = ValidationHelper.MakeCodeIdentifer(cellEntry.Value);
					if (StringHelper.Match(column.Name, "description"))
						description = cellEntry.Value;
				}
			}

			if (string.IsNullOrEmpty(name)) name = description;
			if (description != null) return description;
			else return "";
		}

		#endregion

		#region IXMLable Members
		public override void XmlAppend(XmlNode node)
		{
			var oDoc = node.OwnerDocument;

			//XmlHelper.AddAttribute(node, "key", this.Key);

			var cellEntriesNode = oDoc.CreateElement("cl");
			CellEntries.XmlAppend(cellEntriesNode);
			node.AppendChild(cellEntriesNode);

		}

		public override void XmlLoad(XmlNode node)
		{
			_key = XmlHelper.GetAttributeValue(node, "key", string.Empty);
			var cellEntriesNode = node.SelectSingleNode("cellEntries"); //deprecated, use "cl"
			if (cellEntriesNode == null) cellEntriesNode = node.SelectSingleNode("cl");
			this.CellEntries.XmlLoad(cellEntriesNode);

			this.Dirty = false;
		}
		#endregion

	}
}
